package com.taotao.mapper;


import com.taotao.entity.GateWayEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface MayiktGatewayMapper {

    @Select("SELECT ID AS ID, route_id as routeid, route_name as routeName,route_pattern as routePattern\n" +
            ",route_type as routeType,route_url as routeUrl\n" +
            " ,is_delete as isDelete  FROM mayikt_gateway where is_delete='0'")
    List<GateWayEntity> gateWayAll();


    @Update("update mayikt_gateway set route_url=#{routeUrl} where route_id=#{routeId} and is_delete='0';")
    Integer updateGateWay(@Param("routeId") String routeId,
                          @Param("routeUrl") String routeUrl);
}
